Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# BLANK

The BLANK command sends one or more blank lines to the current outfile. BLANK is typically used only in OLAP DML programs. For example, in a report program, BLANK is commonly used to insert blank lines that separate headings from data or that separate groups of data from one another.

Syntax

BLANK [n]

Arguments

n

  An `INTEGER` expression with a value of `0` (zero) or higher, that specifies how many blank lines should be inserted. When you omit n, Oracle OLAP inserts one blank line. `NA` produces an error.

Examples

Example 8-31 Inserting Blank Lines

This example inserts two blank lines between the title of a report and the column headings. The following lines are from a report program.

    LSIZE = 50
    HEADING WIDTH LSIZE CENTER 'Quarterly Sales Report'
    BLANK 2
    ROW WIDTH 20 'Unit Sales' ACROSS month -
       'Jan96' TO 'Mar96': month

The program produces the following output.

    Quarterly Sales Report

    Unit Sales           Jan96    Feb96    Mar96